{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #3.11-14-2020.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}14 Nov 2020, 22:12:15
{txt}
{com}. 
. 
. 
. **** ACCESS DATABASE ***
. 
. use "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.MANUSCRIPT MODELS.11-06-2020.dta", replace
{txt}
{com}. 
. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. *** CREATE THE EFFECTIVE SAMPLE FROM THE REGRESSION MODELS ESTIMATED IN THE MANUSCRIPT ***
. 
. quietly xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof nongov_recip  ///
> zloyalty2_abszero  electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
> ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
> year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
> fe i(subagency) q(05)
{txt}
{com}. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. 
. *** 1. EVALUATE THE BETWEEN/WITHIN VARIATION IN (1) CA AWARD SIZE & (2) AGENCY HEAD POLICY EXPERTISE TO DETERMINE WHETHER THE VARIATION IS DOMINATED BY BETWEEN-(SUB)AGENCY LEVEL ///
> ***    VARIATION AND THUS HAS INSUFFICIENT WITHIN-AGENCY VARIATION --- AN ADDITIONAL CHECK BESIDES THE (SUB)AGENCY UNIT EFFECTS SPECIFIED IN THE REGRESSION MODEL SPECIFICATIONS ***
. 
. 
. *** DEFINE (SUB)AGENCY AS PANEL IDENTIFIER TO PERFORM PANEL DESCRIPTIVE STATISTICS ***
. 
. xtset subagency
{txt}{col 8}panel variable:  {res}subagency (unbalanced)
{txt}
{com}. 
. 
. 
. *** 1A. COMPUTE PANEL DESCRIPTIVE STATISTICS FOR CA AWARD SIZE [actual constant $ & natural logarithm of actual constant $]***
. 
. xtsum fed_funding if e(sample)

{txt}Variable         {c |}      Mean   Std. Dev.       Min        Max {c |}    Observations
{hline 17}{c +}{hline 44}{c +}{hline 16}
fed_fu~g{col 10}overall {c |} {res} 408215.1    2915038   1.003281   1.04e+09{txt} {c |}{col 69}N =  241730
{col 10}between {c |}{col 31}{res}  1015941   3117.933    4814484{txt} {c |}{col 69}n =      31
{col 10}within  {c |}{col 31}{res}  2899066   -4379673   1.04e+09{txt} {c |} T-bar = 7797.74

{com}. *
. display 1015941 / 2899066
{res}.35043735
{txt}
{com}. *
. *
. xtsum ln_fed_funding if e(sample)

{txt}Variable         {c |}      Mean   Std. Dev.       Min        Max {c |}    Observations
{hline 17}{c +}{hline 44}{c +}{hline 16}
ln_fed~g{col 10}overall {c |} {res} 11.02029   2.062233   .0032754   20.75793{txt} {c |}{col 69}N =  241730
{col 10}between {c |}{col 31}{res} 1.386188   8.044926   14.47906{txt} {c |}{col 69}n =      31
{col 10}within  {c |}{col 31}{res}  1.80698  -1.375174   21.90737{txt} {c |} T-bar = 7797.74

{com}. *
. display 1.386188 / 1.80698
{res}.76712969
{txt}
{com}. 
. 
. 
. *** 1B. COMPUTE PANEL DESCRIPTIVE STATISTICS FOR AGENCY POLICY HEAD EXPERTISE ***
. 
. xtsum zpolicy2_abszero if e(sample)

{txt}Variable         {c |}      Mean   Std. Dev.       Min        Max {c |}    Observations
{hline 17}{c +}{hline 44}{c +}{hline 16}
zpolic..{col 10}overall {c |} {res} 1.991068   .9070974   9.81e-08   4.377769{txt} {c |}{col 69}N =  241730
{col 10}between {c |}{col 31}{res}  .691824   .7945763   3.533331{txt} {c |}{col 69}n =      31
{col 10}within  {c |}{col 31}{res} .6338932   .2963099   3.674538{txt} {c |} T-bar = 7797.74

{com}. *
. display 0.691824 / 0.6338932
{res}1.0913889
{txt}
{com}. 
. 
. *** NOTE: There is clearly sufficient between and within-(sub)agency variation in both CA award sizes and Agency Head Policy Expertise *** 
. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. *** 2. EVALUATING BALANCE IN BINARY INDICATORS TO AVOID LOW POWER TESTS ***  
. 
. tab ceo if e(sample)

        {txt}ceo {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    193,310       79.97       79.97
{txt}          1 {c |}{res}     48,420       20.03      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab privmgt if e(sample)

    {txt}privmgt {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    153,437       63.47       63.47
{txt}          1 {c |}{res}     88,293       36.53      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab electionyear if e(sample)

   {txt}Election {c |}
 year dummy {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    168,824       69.84       69.84
{txt}          1 {c |}{res}     72,906       30.16      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab unified if e(sample)

    {txt}unified {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    159,713       66.07       66.07
{txt}          1 {c |}{res}     82,017       33.93      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab pres_party if e(sample) 

 {txt}pres_party {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    129,512       53.58       53.58
{txt}          1 {c |}{res}    112,218       46.42      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab house_majority if e(sample)

{txt}house_major {c |}
        ity {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    224,142       92.72       92.72
{txt}          1 {c |}{res}     17,588        7.28      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab any_chair if e(sample)

   {txt}MC chair {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    232,086       96.01       96.01
{txt}          1 {c |}{res}      9,644        3.99      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab house_app if e(sample)

  {txt}house_app {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    210,162       86.94       86.94
{txt}          1 {c |}{res}     31,568       13.06      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab house_ways if e(sample)

 {txt}house_ways {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    225,408       93.25       93.25
{txt}          1 {c |}{res}     16,322        6.75      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab action_a if e(sample)

   {txt}action_a {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    117,526       48.62       48.62
{txt}          1 {c |}{res}    124,204       51.38      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. *
. tab action_b if e(sample)

   {txt}action_b {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    173,690       71.85       71.85
{txt}          1 {c |}{res}     68,040       28.15      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. 
. 
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. **************************************************************************************************************************************************************************************
. 
. 
. *** 3. COMPUTE PERCENTAGE OF CA AWARDS UNDERTAKEN FOR RECESS PRESIDENTIAL APPOINTED (SUB)AGENCY HEADS [Only 98 CA Awards out of 241,730: 0.04%]***
. 
. tab recess if e(sample)

     {txt}Recess {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}    241,632       99.96       99.96
{txt}          1 {c |}{res}         98        0.04      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    241,730      100.00
{txt}
{com}. 
. 
. 
. ****Supplementary Analysis # 3 (Linear Trends in CA Award Size and Agency Head Policy Expertise: Bivariate Linear Prediction Fits) Full Sample, plus disaggregated by partner recipient types.***
. 
. ***ALL CAs***
. twoway (lfitci ln_fed_funding year if e(sample), ytitle(Log of CA Awards) ytitle(, margin(small)) xtitle(Year) title(FIGURE SI-3.1: Relationship Between CA Award Size & Agency Head Policy Expertise With Respect to Time, size(small))  subtitle(Full Sample, size(small)) legend(off) scheme(sj)) (lfitci zpolicy2_abszero year if e(sample), yaxis(2))
{res}{txt}
{com}. *
. save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.1", replace
{txt}(note: file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.1 not found)
file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.1 saved

{com}. 
. 
. ***Government Partner***
. 
. twoway (lfitci ln_fed_funding year if e(sample) & gov_recip==1, ytitle(Log of CA Awards) ytitle(, margin(small)) xtitle(Year) title(FIGURE SI-3.2: Relationship Between CA Award Size & Agency Head Policy Expertise With Respect to Time, size(small)) subtitle(Government Partner, size(small)) legend(off) scheme(sj)) (lfitci zpolicy2_abszero year if e(sample) & gov_recip==1, yaxis(2))
{res}{txt}
{com}. *
. save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.2", replace
{txt}(note: file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.2 not found)
file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.2 saved

{com}. 
. 
. ***Non-Governmental Partner***
. 
. twoway (lfitci ln_fed_funding year if e(sample) & gov_recip==0, ytitle(Log of CA Awards) ytitle(, margin(small)) xtitle(Year) title(FIGURE SI-3.3: Relationship Between CA Award Size & Agency Head Policy Expertise With Respect to Time, size(small)) subtitle(Non-Government Partner, size(small))  legend(off) scheme(sj)) (lfitci zpolicy2_abszero year if e(sample) & gov_recip==0, yaxis(2))
{res}{txt}
{com}. *
. save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.3", replace
{txt}(note: file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.3 not found)
file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.3 saved

{com}. 
. 
. ***Nonprofit Partner***
. 
. twoway (lfitci ln_fed_funding year if e(sample) & nonprofit_recip==1, ytitle(Log of CA Awards) ytitle(, margin(small)) xtitle(Year) title(FIGURE SI-3.4: Relationship Between CA Award Size & Agency Head Policy Expertise With Respect to Time, size(small)) subtitle(Nonprofit Partner, size(small))  legend(off) scheme(sj)) (lfitci zpolicy2_abszero year if e(sample) & nonprofit_recip==1, yaxis(2))
{res}{txt}
{com}. *
. save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.4", replace
{txt}(note: file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.4 not found)
file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.4 saved

{com}. 
. 
. ***Private Sector Partner***
. 
. twoway (lfitci ln_fed_funding year if e(sample) & private_recip==1, ytitle(Log of CA Awards) ytitle(, margin(small)) xtitle(Year) title(FIGURE SI-3.5: Relationship Between CA Award Size & Agency Head Policy Expertise With Respect to Time, size(small)) subtitle(Private Sector Partner, size(small))  legend(off) scheme(sj)) (lfitci zpolicy2_abszero year if e(sample) & private_recip==1, yaxis(2))
{res}{txt}
{com}. *
. save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.5", replace
{txt}(note: file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.5 not found)
file C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\Graphics\Supplementary Analysis 3\Figure SI-3.5 saved

{com}. 
. 
. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #3.11-14-2020.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}14 Nov 2020, 22:13:22
{txt}{.-}
{smcl}
{txt}{sf}{ul off}